<%@include file="Common.jsp"%>
<%@page import="org.apache.commons.httpclient.HttpStatus"%>
<%@page import="org.apache.commons.httpclient.methods.GetMethod"%>
<%@page import="org.apache.commons.httpclient.HttpClient"%>
<%@page import="java.net.HttpURLConnection"%>
<%@page import="java.io.InputStreamReader"%>
<%@page import="java.io.BufferedReader"%>
<%@page import="java.io.InputStream"%>
<%@page import="java.net.URLEncoder"%>
<%@page import="java.io.DataInputStream"%>
<%@page import="java.net.URL"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Effective Navigation of Query Results Based on Concept Hierarchies</title>
<link rel="stylesheet" type="text/css" href="style.css" />
<script type="text/javascript" src="tabber.js"></script>
<link rel="stylesheet" href="example.css" TYPE="text/css" MEDIA="screen">
<link rel="stylesheet" href="example-print.css" TYPE="text/css" MEDIA="print">

<script type="text/javascript">

    function init(va)
    {
        if(va!=null)
        document.form1.Search_Term.value=va;
    }

/* Optional: Temporarily hide the "tabber" class so it does not "flash"
   on the page as plain HTML. After tabber runs, the class is changed
   to "tabberlive" and it will appear. */

document.write('<style type="text/css">.tabber{display:none;}<\/style>');
</script>
<link rel='stylesheet' href='tree.css'>
	<script language="javascript" src="tree.js"></script>

</head>
  


<body >
     <jsp:include page="Header.jsp" flush="true"/> 

  <div id="wrapper" align="center">

   

		  
<table width="961" border=0 cellpadding='10' cellspacing=0  align="center"><tr><td width="246" height="429" valign="top"  style="border: 3px solid green;">

<p align="left"><font color="#FF0000"><strong>COLLECT BIONAV DATABASE INFORMATION 
            </strong></font></p>
<br>
          <font color="#FF0000"><strong>DYNAMIC NAVIGATION</strong></font><br>
<br>
          <table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><a id="xproducts" href="javascript:Toggle('products');"><img src='folder.gif' width='16' height='16' hspace='0' vspace='0' border='0'></a></td>
              <td width="125"><b>Search Bio database</b></table>
	<div id="products" style="display: none; margin-left: 2em;">
			<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td><a href="Search_2.jsp?category=Biochemical Nomenclature Database" >Biochemical Nomenclature Database</a></td></tr></table>
			<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td><a href="Search_2.jsp?category=Carbohydrate Databases" >Carbohydrate Databases</a></td></tr></table>
				<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><a id="xspecs" href="javascript:Toggle('specs');"><img src='folder.gif' width='16' height='16' hspace='0' vspace='0' border='0'></a></td><td><b>other databases</b></table>
					<div id="specs" style="display: none; margin-left: 2em;">
							<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td width="162"><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="master">Enzyme Databases</a></td></tr></table>
							<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td width="165"><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="master">Genome Databases</a></td></tr></table>
					<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="master">Gene Nomenclature Database</a></td></tr></table>
					<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td width="168"><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="master">Genome Databases - Plant</a></td></tr></table>
					<table width="140" border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td width="188"><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="master">Genome Databases - Prokaryotic</a></td></tr></table>
					
					</div>
				</div>

<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><a id="xsupport" href="javascript:Toggle('support');"><img src='folder.gif' width='16' height='16' hspace='0' vspace='0' border='0'></a></td>
              <td width="160"><b>Search Medicine db</b></table>
	<div id="support" style="display: none; margin-left: 2em;">
		<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="master">Lipid Databases</a></td></tr></table>
		<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="_blank">Metabolic Pathway Databases</a></td></tr></table>
		<table border=0 cellpadding='1' cellspacing=1><tr><td width='16'><img src='text.gif' width='16' height='16' hspace='0' vspace='0' border='0'></td><td><a href="http://www.science.co.il/Biomedical/Biochemical-Nomenclature.asp" target="_top">Mutation Databases</a></td></tr></table>
	</div>

<br>
<br>

         </td>
		 <td width="30"></td>
		  
      <td  valign="top" ><strong><font color="#FF00CC" size="4">Bio Database Results</font></strong> 
        <%

try

{

Connection con=null;

Statement st;

ResultSet rs;



String sql=null;



String cat=request.getParameter("category");  

//out.println(cat);



if(cat!=null&&cat.equalsIgnoreCase("Biochemical Nomenclature Database")) 

{

	sql="select * from bio where category='Biochemical Nomenclature Database'";

}

else if( cat!=null&&cat.equalsIgnoreCase("Carbohydrate Databases")) 

{

	sql="select * from bio where category='Carbohydrate Databases'";

}



else 

{

	sql="select * from bio";

}                     	 





 Class.forName("com.mysql.jdbc.Driver");

con=DriverManager.getConnection("jdbc:mysql://localhost/movedb","root","root");


st=con.createStatement();

rs=st.executeQuery(sql);



while(rs.next())

{



String database=rs.getString("database");





%>
        <table><tr><td width="358" height="39"><font color="#000000" size="+1"><%=database%>&nbsp; &nbsp;</font></td></tr></table>
    

  


		 

		
		  
		 
		  
		 
		 <%

}



}





catch(Exception e)

{

out.println("Exception:"+e.getMessage());

//e.printStackTrace();

}

%>

		  </tr></table>
		 </div>
		 
	
</form>     
</body>
</html>
